The same result can be accomplished with a view rather than using computed columns in a table. That reduces the file size. Your report is based on the view, not a table.
Randy ________________________________ From: [email protected] <[email protected]> on behalf of Bo Franzén <[email protected]> Sent: Thursday, June 3, 2021 8:29 AM To: [email protected] <[email protected]> Subject: SV: [RBASE-L] - How to make three columns into one? As usual, this group solved my problems. Many thanks! Y s Bo Franzén University of Stockholm ________________________________ Från: [email protected] <[email protected]> för [email protected] <[email protected]> Skickat: den 27 maj 2021 20:32:52 Till: [email protected] Ämne: RE: [RBASE-L] - How to make three columns into one? Bo, I had to deal with the exact situation before and almost always end up creating one or more computed columns that I can use freely without losing the original values or having to parse the name. For example: FirstName MiddleName LastName PrefAddress CompFullName CompShortName CompShortAddress Sarah Emily Valencia Ms. Sarah Emily Valencia Valencia, S Ms. Valencia The first 4 columns hold the original data and the last 2 the computed data, No need to update, simply enter data in the first 4 columns and the others are computed automatically. It is also much easier data entry-wise Now you have a lot of flexibility, for example, you can easily search by any of the individual columns. You can also use the individual columns for thinks like greetings: Dear Ms. Valencia, Or… Dear Sarah, On reports and forms without having to ever recalculate/parse individual components and you still have the original data. You can see the potential of using some of the features readily available. I do the same for things like City, State and Zip Code that are usually used together in one line, obviously in the US: City State Zip CompCSZ Olathe KS 66062 Olathe, KS 66062 Now, instead of having to either merge 3 columns or enter and space them properly in a report, you only need to insert one column. Hopefully, the information above is of use. Javier, Javier Valencia, PE [email protected]<mailto:[email protected]> O: 913-829-0888 C: 913-915-3137 From: [email protected] <[email protected]> On Behalf Of Bo Franzén Sent: Thursday, May 27, 2021 10:12 AM To: [email protected] Subject: SV: [RBASE-L] - How to make three columns into one? Hello again, Well, forget the date aspect. I just wonder how to move (UPDATE) the text in two or three columns into one column. Say in making name middlename and surname into one column. Simply to add the latter to the former (name). Y s Bo Franzén Stockholm University ________________________________ Från: [email protected] <[email protected]> för A. Razzak Memon <[email protected]> Skickat: den 26 maj 2021 22:23:34 Till: [email protected] Ämne: Re: [RBASE-L] - How to make three columns into one? Bo, If I understand your question correctly ... Try ADDDAY and ADDMON functions to accomplish your goal. It seems that you maybe asking for (RDATE(mon,day,yr)) function. Hope it helps! Very Best R:egards, Razzak At 03:46 PM 5/26/2021, Bo Franzén wrote: >Hello! > >This is painful to admit since I have done this >at the R>prompt more than once. But now I have >forgotten how. I have a big database from a >colleague of mine with medieval prises that is >going to be printed. It starts with three small >text columns for each row for setting the date >of the price. Let us translate them into Year >Month Day, although it is not something that >always can be converted into a Date format like >1471-10-10. Due to the source material it can be >1471-1472 etc. In my notes I have found that >Gunnar Ekblad once teached me that a plus [+] >does not add a space, while an ampersand [&] >does. But what command should be used to add >month and day to the year column? UNION? > >Bo Franzén > >University of Stockholm -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1N0naj-1lXvC909qP-00wpvX%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f5010816579644749ba90ab30477bb2c%40ekohist.su.se<https://groups.google.com/d/msgid/rbase-l/f5010816579644749ba90ab30477bb2c%40ekohist.su.se?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAAAjhOPnuF5Iv5oXNBZjYXUBAAAAAA%3D%3D%40vtgonline.com<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAAAjhOPnuF5Iv5oXNBZjYXUBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/ae3d30079ca14c89a3c585372934da69%40ekohist.su.se<https://groups.google.com/d/msgid/rbase-l/ae3d30079ca14c89a3c585372934da69%40ekohist.su.se?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR11MB151281ED832BE7CC85FD09E8C73B9%40CY4PR11MB1512.namprd11.prod.outlook.com.
