SOLVED
Text to columns (add header)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tiverson
8 - Asteroid
‎12-14-2022
11:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a crazy text file that I need to parse out and create consistent columns.
My file does not have a header row, but I know what it needs to be:
How can I add the header column titles and parse out the file into columns (based on a fixed width)
Text file:
I need to add the following column titles (plus number of characters)
System - 3
Posting Date - 8
Doc Date - 8
Account - 10
Text - 50
Amount = 13
There are a lot more I need to add and the files I have are huge, but if I could get an example of the above items I believe I can finish up the rest.
Thanks,
Todd
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
1 REPLY 1
Felipe_Ribeir0
16 - Nebula
‎12-14-2022
11:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator