Member Avatar for ITKnight

Hi all,
How i can split a string that include spaces by "&" ?
I already used split function but there are problem with spaces.

thanks.

  • 5 Contributors
  • 7 Replies
  • 208 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by ITKnight
Member Avatar for WaltP

I use instr() , mid() , right() , and left()

Edited by WaltP because: n/a
Member Avatar for debasisdas

Lets see your code .

Member Avatar for ITKnight

Hi,
this part of code :

Arr1 = Split("aaa bbb&ccc ddd&eee",4)

it returns the values aaa ccc eee
ignored the values after the spaces.

Best Regards,
Thank You

Member Avatar for Jx_Man

See if this help :

Arr1 = Split("aaa bbb&ccc ddd&eee","&")
commented: Thanks +4
Member Avatar for WaltP

Sorry, didn't remember there was a split command. Ignore my post

Member Avatar for sidnei

Why are you using the 4 in second parameter?
Did you mistype it?

Try simply

Arrl = Split("aaa bbb&ccc ddd&eee", "&")

It works fine for me.

And Msgbox Split("aaa bbb&ccc ddd&eee","&")(0) return "aaa bbb".

Regards,
Sidnei

Hi,
this part of code :

Arr1 = Split("aaa bbb&ccc ddd&eee",4)

it returns the values aaa ccc eee
ignored the values after the spaces.

Best Regards,
Thank You

commented: Thanks dude, its working. +4
Member Avatar for ITKnight

Thanks guys, its working.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.