This may be a simple one but I'm kind of new here.
Simply trying split a string row into several columns. A simple 'text to columns' should work but the problem is I'm not certain how to handle the space delimiter. For instance there are 5 values, the first being a name and the rest numeric values. Space being the delimiter how to handle the spaces within the name?
Ex:
Purchaser
Joseph Smith 5.5 7.6 8.3 5.5
Sara Jacobs 3.4 5.6 7.7 5.5
Need something like:
Purchaser Value1 Value2 Value3 Value4
Joseph Smith 5.5 7.6 8.3 5.5
Sara Jacobs 3.4 5.6 7.7 5.5
Any suggestions?
Thanks!!!
Solved! Go to Solution.
Hi @sbfall96 ,
Regex tool is an option .
Thanks. Will take a look.
Hi @benakesh,
Thats should work fine to get me to a point. trying to get those results you had above joined up with another input. Seems simple enough but...
For example:
Input1
Store (header)
XYZ Store
123 Store
input2
Category (header)
Customer Service Rating1 Rating2 (the ratings are in row order, for each company)
Sales 3.6 4.5
returns 5.5 5.5
Need to report off of something like:
-- Customer Service XYZ Store 123 Store
Sales 3.6 4.5
returns 5.5 5.5