• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Wrap String

Hi: This is the the string.
TxtString1 = "DBTRADDR" & "," & mAddress1A & "," & mAddress1B & "," & mCity1 & "," & mState1 & "," & mZip1 _
& "," & """"

And this is the result
DBTRADDR,100 E GRAND BLVD STE 100,"",CORONA,CA,928792222,""

My question is how to i put a double quotation mark around each field. Even if there is a value or no value in it. It must be wrap with double quotation mark like that. I try it but it not wrap the fields which have value in it.
DBTRADDR,"100 E GRAND BLVD STE 100","","CORONA","CA","928792222",""

Thanks.

TxtString1 = "DBTRADDR" & "," & iif (IsNull(mAddress1A), chr(34) & chr(34), mAddress1A) & "," &  iif (IsNull(mAddress1B), chr(34) & chr(34), mAddress1B) & "," &  iif (IsNull(mCity1), chr(34) & chr(34), mCity1) & "," &  iif (isNull(mState1) , chr(34) & chr(34), mState1) & "," &  iif (isNull(mZip1), chr(34) & chr(34), mZip1) _
& "," & """"
0
mustish1
Asked:
mustish1
1 Solution
 
kingtam2000Commented:
If you want to put quotation marks around the fields, then you would add "" (double quotes) before and after each field.  So, taking your string (I'm not sure if you want to put quotation marks around DBTRADDR, I'm assuming you don't):
TxtString1 = "DBTRADDR" & ", """ & mAddress1A & """, """ & mAddress1B & """, """ & mCity1 & """, """ & mState1 & """, """ & mZip1 & """, """ & """"
You can join up the first and last strings if you wanted to so it would be:
TxtString1 = "DBTRADDR, """ & mAddress1A & """, """ & mAddress1B & """, """ & mCity1 & """, """ & mState1 & """, """ & mZip1 & """, """""

If you wanted something different or need more help, just post a comment.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now