Regex to parse numbers and text
- 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, I have the following data that needs to be entered in 5 columns:
How can a Regex be used to do this?
Thanks.
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wellington_costa ,
This is a fixed width file problem so you can open your txt file as a .flat file and select the 'fixed width text file' as image below.
Then after confirming, it will open a layout pop-up where, by clicking, you decide where to cut your columns.
I'm sharing an example with you. To open the file layout, see image below.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
H/i, @fmvizcaino.
sorry, the data is incomplete, not all strings are the same length. I updated the data.
Thank you for your help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wellington_costa ,
As I'm looking at it, I will still use a bit of fixed width for the first 2 columns and them regex for the last 3.
Example attached.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked perfectly, thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator