leeknay
commented
3 years ago Hi Brian, Thanks for the reply and the info. I've been successful coding an extractor with the pipe character as a delimiter. That's very straightforward. My issue is when using the "Create EXTRACT Script" option in AzureDatalakeToolsForVSCode, the delimiter choices appear hardcoded. @.***D724A1.02985030]
From: Brian Freeman @.> Sent: Monday, March 29, 2021 9:46 AM To: microsoft/AzureDatalakeToolsForVSCode @.> Cc: Lee, Shawn @.>; Author @.> Subject: Re: [microsoft/AzureDatalakeToolsForVSCode] Pipe delimiter not an option in "Create EXTRACT Script" (#22)
I that doesn't work:
- Reformat data with a Data Flow, or script beforehand
- Create Custom Extractor in cs
https://www.sqlservercentral.com/steps/stairway-to-u-sql-level-22-creating-a-custom-extractor#:~:text=That%E2%80%99s%20where%20custom%20extractors%20come%20in.%20U-SQL%20provides,scripts%2C%20just%20like%20any%20of%20the%20built-in%20extractorshttps://urldefense.com/v3/__https:/www.sqlservercentral.com/steps/stairway-to-u-sql-level-22-creating-a-custom-extractor*:*:text=That**Bs*20where*20custom*20extractors*20come*20in.*20U-SQL*20provides,scripts*2C*20just*20like*20any*20of*20the*20built-in*20extractors__;I37igJklJSUlJSUlJSUlJSUlJSU!!DZ3fjg!uTGl9z3ghDn7h1nrWG7usWSfurYpRyULy_VuYpsBLIuFUgDXG0LbKpy60RMtt3Z69xQ$.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/microsoft/AzureDatalakeToolsForVSCode/issues/22*issuecomment-809439644__;Iw!!DZ3fjg!uTGl9z3ghDn7h1nrWG7usWSfurYpRyULy_VuYpsBLIuFUgDXG0LbKpy60RMtgfxgX9I$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ABYI5NV7VFUWYMMMF7CA4BTTGCHDJANCNFSM4Z6PGD5A__;!!DZ3fjg!uTGl9z3ghDn7h1nrWG7usWSfurYpRyULy_VuYpsBLIuFUgDXG0LbKpy60RMtlFqj9E0$.
iguanaware
"Create EXTRACT Script" doesn't seem to support any delimiters other than , ; & tab space. Wish there was a way I can use a pipe delimiter