Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In below attached application i have a policy number column and in that i am having policy numbers starting with Numbers and Characters
But i want to load policies starting with characters only..how i can do this.
Please help..
Thanks in advance.
Hi Prasad,
sure no problem.
Below you will find a possible solution using match:
A:
LOAD PolicyNumber
FROM
[policynumbers.xlsx](ooxml, embedded labels, table is Sheet1)
WHERE NOT match(left(PolicyNumber,1),0,1,2,3,4,5,6,7,8,9);
Kind regards,
Hi Prasad,
you can use the alt function to determine if the first character is a number.
A:
LOAD IF(alt(left(PolicyNumber,1)),PolicyNumber) as PolicyNumber
FROM
[policynumbers.xlsx]
(ooxml, embedded labels, table is Sheet1);
Find sample attached.
Let me know if this helps.
Kind regards,
Hi Santiago,
Thanks for your help..but actually want other way round. Means I want policy numbers starting with charters only should get upload.
Thanks in advance.
Hi Prasad,
my bad, i interpreted totally the opposite.
Here is a possible solution attached.
Please let me know if it fits your needs.
Kind regards,
Thanks no problem at all...As I have a personal edition i can not open your application so can you please paste the solution the way you posted above.
Hi Prasad,
sure no problem.
Below you will find a possible solution using match:
A:
LOAD PolicyNumber
FROM
[policynumbers.xlsx](ooxml, embedded labels, table is Sheet1)
WHERE NOT match(left(PolicyNumber,1),0,1,2,3,4,5,6,7,8,9);
Kind regards,
Hi,
Thank you very much Santiago...very helpful.