Parsing tool Regex
- 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
Hello,
I am trying to get some information inside the columne “ value” and put it in other column.
Source:
transaction number | value |
4670 | Installment number : 1 => 1
New line |
4678 | Installment number : 1 => 1 New line |
I would like the output to be
transaction number | Payment method description | Payment method description |
4670 | American Express US$ => American Express US$ | Cash US$ |
4678 | VISA US$ => VISA US$ | Cash US$ |
I am trying to use the regex parsing tool but when I do (.*)(Payment method description)(.*) it only take the last one of payment method description, but I want both of information that it is contain inside the cell. This table are just example my dataset have multiple row.
Thanks in advance!!
Solved! Go to Solution.
- Labels:
- Datasets
- Optimization
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Tommy23 One way of doing this
- 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
