String Parsing

Krish

Hi All,

I have string parsing requirement as follows.

"Kannan ABCD Building" -> Source Text

I need to parse first 10 chars as Name.
remaining as Address.
Like

Kannan ABC as Name
But remaining as Address however like this
ABCD Building

That is I have to see if the 11 th charcter is part of particular word,If so I have to parse that too as Address

Could you please advice on how to achive this.

Currently I have following:

To Parse Name:

Left([SourceText],10)

To Parse Address:

IF Length([SourceText]) > 10 THEN

Substring([SourceText],10,Length([CompanyName])-1)

Thanks,

Krish

Parse

Dynamic Processing

Accepted answers

MarqueeCrew

@Krish,

In line with how you were attempting this.....

If the first word is more than 11 bytes, then get that first word as Name, otherwise take the leftmost characters up to the last space as Name.

Name =

IF Length(GetWord([String], 0)) >= 10
	THEN Getword([String],0)
ELSE
	Trim(Left([String],10-FindString(ReverseString(left([String],10)),' ')))
ENDIF

Address =

Trim(Replace([String],[Name],''))

Seems to work for me....

Cheers,

Mark

All comments

MarqueeCrew

@Krish,

In line with how you were attempting this.....

If the first word is more than 11 bytes, then get that first word as Name, otherwise take the leftmost characters up to the last space as Name.

Name =

IF Length(GetWord([String], 0)) >= 10
	THEN Getword([String],0)
ELSE
	Trim(Left([String],10-FindString(ReverseString(left([String],10)),' ')))
ENDIF

Address =

Trim(Replace([String],[Name],''))

Seems to work for me....

Cheers,

Mark

Krish

Thanks a lot.The reverse string usuage helped to identify proper start index location.

I re arranged for my requirement.It worked.

Thanks!

Krish

Thanks a lot.The reverse string usage helped to identify proper start index location.

I re arranged for my requirement.It worked.

Thanks!

Krish

Thanks.It worked!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177