Txt file Trailing Whitespace. Alignment affected
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All, can someone help me to delimit the data below.
For the amounts it should have 3 columns
debit, credit, balance
I tried to used the replace the whitespaces using regex and replace it with pipe(|). However, the other whitespaces are delimited and this should have bakances of 0. I attached the sample input.
The picture is the desired output.
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the idea. However, this still does not work , there are instances wherein the amounts are not aligned properly thus being cutoff in another column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Inactive User ,
Is it possible to define more clearly which number should come into which column?
Row 1,2,4 have two numbers, while Row 3 has one number.
Also it is not clear which the two numbers in Row 4 belong to.
It is hard to guess from your description and data.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The output will somehow look like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Anon, part of the problem is your sample data is too small, and not being familiar with it, we can't tell what that third row is with only a "0" is supposed to represent, debit? credit? balance?
Should the 3 columns all be the same width? If there are no values in that width then it's empty?
I can't help you without knowing how to treat various conditions.
Here is what I have, which to an extent isolates the entries to deal with, and separating off the data you want to parse, but need more information to help any further.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi thank you for your reply. I can't seem to run the workflow. Here is a sample desired output
