Search found 157 matches

by new_user
Tue May 06, 2014 12:19 pm
Forum: VBScript
Topic: Enclose attribute (variable) in quotes ""
Replies: 3
Views: 5564

Re: Enclose attribute (variable) in quotes ""

Thank you for the help, I will give that a shot.
by new_user
Tue May 06, 2014 10:53 am
Forum: VBScript
Topic: Enclose attribute (variable) in quotes ""
Replies: 3
Views: 5564

Enclose attribute (variable) in quotes ""

My code works fine but I have not successfully been able to have each output variable be enclosed by quotes which is a late ask so I did not want to transfer this to ps. How can I ensure each variable/attribute be written as "username";"givenName" etc instead of username;givenName? Code attached. Th...
by new_user
Thu Jan 02, 2014 6:21 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

So there is no way to pull the data from the description field into one line of output with a vbscript, so it does not break to a new line? I thought your new concat function was doing that with the echo statement, i was trying to change from echo to a var name so I could add it to my objFile.WriteL...
by new_user
Thu Jan 02, 2014 5:19 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

Lets try this again. They I am sure pasted contents from a ticketing system into the Description field. The normal method I use to grab that does not work in this case because of this, hence my original post. The change in function with your wscript.echo seems to help. I wanted to plug that into my ...
by new_user
Thu Jan 02, 2014 5:01 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

Copying your last post which looks to be a duplicate of mine yields the same output issue. Assigning a new variable so I can utilize it to write the output per your post. I do have it formatted its just not transferring over via copy and paste.
by new_user
Thu Jan 02, 2014 4:42 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

Such as below: This throws it to the next line instead of the same: desc = adoRecordset.Fields("Description").Value if IsArray(desc) Then StrDescNew = Join(desc,"|") Else If Not IsNull(desc) THen StrDescNew1 = desc Else StrDescNew = "DESCRIPTION_IS_NULL" End If End If
by new_user
Thu Jan 02, 2014 4:04 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

I believe that worked but is difficult to read without the other attributes. Of course I added that function to my original code commenting out the old and cannot just output the "desc" variable that you have echo'ing. How do I assign another to it so I can just write it out with the other output?
by new_user
Thu Jan 02, 2014 2:32 pm
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

When I did that it does not output any of the description field. I made a grammar change to a few variables and attached the code. Obviously I am missing something here. Thank you.
by new_user
Thu Jan 02, 2014 9:24 am
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

Changed the function to the below with same result. arrDesc = adoRecordSet.Fields("description").Value ' The description attribute is multi-valued, but ' there is never more than one item in the array. arrDesc = adoRecordset.Fields("description").Value If IsNull(arrDesc) Then strDisplayDescription =...
by new_user
Thu Jan 02, 2014 6:57 am
Forum: VBScript
Topic: Description field line breaks when exporting in vbscript
Replies: 30
Views: 37477

Re: Description field line breaks when exporting in vbscript

The does not match up to the output I see. The description field is multi-valued and it pulls the entire description, in only certain instances where the description happens to be over x characters does it break to a new line when writing the output. Guess I am missing something. That same function ...