How to get values which exists in Second place

[#1]

Hi,

Please find attached excel file.

I need to get only the values which exists in SECOND place without blanks.

For Eg:

 
54 Old Forge Lane, BeachRoad, County Down, US, BT67 U89

I need to get the value BeachRoad only

Please can anyone help me how to get this.

Thanks.

[Anonymous · Accepted solution]

=subfield ( '54 Old Forge Lane, BeachRoad, County Down, US, BT67 U89' , ',' , 2 )

[Gysbert_Wassenaar]

subfield( Address, ',', 2)

[Anonymous]

Load

Address,
Trim(subfield( Address, ',', 2)) AS Address2
FROM
(ooxml, embedded labels, table is Sheet2);

[magavi_framsteg]

Hi Amelia.

I believe I saw something on this exact topic late last year.

Please see this thread and I wish you the best of luck in getting correct results: How to get correct values

Kind regards

Magnus Åvitsland

BI Architect Consultant

Framsteg Business Intelligence Corp.

[#6]

Hi Amelia,

Please find the attachment.

Santhosh

[#7]

Thanks it's working.

[#8]

Thanks for sending the qvw file and it's working.

[#9]

Thanks.

[#10]

Thanks for your prompt reply and it's working