| Author |
Message
|
| raana |
 Posted: Fri Feb 17, 2017 2:39 am Post subject: DFDL Parsing for the file with semicolon |
 |
|
Newbie
Joined: 15 Jan 2017
Posts: 6
|
How to parse the file which is having the semicolon as field element separator, as semicolon is not listed in the Message model wizard for "field separation".
EC030954-001;005;390;BOO2
Last edited by raana on Mon Feb 20, 2017 12:06 am; edited 1 time in total |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Feb 17, 2017 6:21 am Post subject: Re: DFDL Parsing for the file with semicolon |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| raana wrote: |
| How to parse the file which is having the semicolon as field element separator, as semicolon is not listed in the Message model wizard for "field separation". |
Don't use the wizard.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| timber |
| Posted: Fri Feb 17, 2017 6:24 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| Or use the 'Records and fields' option instead of the 'CSV' option. |
|
| Back to top |
|
|
| raana |
| Posted: Sun Feb 19, 2017 9:40 pm Post subject: |
|
|
Newbie
Joined: 15 Jan 2017
Posts: 6
|
Thank you vitor and timber for your responses.
A simple semicolon in that wizard would made my day much easier. Now i need to find alternate ways of achieving the results.  |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 21, 2017 5:31 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| raana wrote: |
| A simple semicolon in that wizard would made my day much easier. |
Raise an RFE. Seriously.
| raana wrote: |
| Now i need to find alternate ways of achieving the results. |
Given the simplicity of your record format and the suggestion of @timber that's not hard.
If you prefer to avoid even that level of original thought, use the wizard to model your record as if the pipe character (or other listed delimiter) was being used. Then edit each occurrence of that delimiter to be a semicolon and see how that works.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
