Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have sample date from a client, it comes in a very strange format, one line:
COR032532917ý17ý991701ý1706ý990225191ý31608ýMISC-TGT1ý1ý14171ý800ý03616ý0ý405IN14754NIM1NIMEMASCO8379ý8379ý8240083ýý
when pasted into word the records are split:
COR
032
5329
17ý17ý99
1701ý1706ý9902
25191ý31608ýMISC-TGT
1ý1ý1
4171ý800ý0
3616ý0ý405
IN
14754
NIM1
NIMEMA
SCO
8379ý8379ý8240
083
ýý
Lines 4-9 and 15 have 3 records per line, I want to load this into Qlikview and as a result have 3 lines. I'm using the SubField but I'm ending up with every possible variation - 407 lines... I attach my qvw, I would gladly appreciate some help
Thank you
Kasia
For now we just need to let the client know that we can work with their data and it looks like we can, thank you for your first solution! The last records - 17, does have 'ý', but we don't know what this data mean so it's hard to say at this stage.. Thank you for your help!